package com.qiangqiang.entity;

import lombok.Data;

import javax.persistence.*;
import java.util.Date;

/** 卫生检查表Id
 * Created by q on 2018/2/1.
 */
@Entity
@Data
/**
 * 调用存储过程
 */
@NamedStoredProcedureQueries({@NamedStoredProcedureQuery(name="insert_sanitation",procedureName = "s_dormitory.insert_sanitation",
        parameters = {@StoredProcedureParameter(mode = ParameterMode.IN,name = "scoreId",type = String.class),
                @StoredProcedureParameter(mode = ParameterMode.IN,name = "dId",type = String.class),
                @StoredProcedureParameter(mode = ParameterMode.IN,name = "level",type = Integer.class)})})
public class Sanitation{
    /**
     * 卫生检查表id
     */
    @Id
    private int sanId;
    /**
     * 加减分表的id
     */
    private String scoreId;
    /**
     * 宿舍号
     */
    private String dId;
    /**
     * 0,1,2 共三个等级
     */
    private int level;
    /**
     * 时间
     */
    private Date time;
}
